The Dissect the Sales Desk group of fields on the Config GL Interface screen allows you to customise the integration of Sales and Cost of Sales to the Micronet General Ledger. It also allows for multiple Trade Debtor control accounts in the Balance Sheet of the General Ledger.
To complete the Dissect the Sales Desk fields:
Refer to "Edit - General Ledger Config - Distribution Interface".
Micronet displays the Dissect the Sales Desk fields.
Select an integration option:
|
Option |
Description |
|
Total |
The Distribution system searches for a GL interface record labelled TOTAL and produces accounting entries (financial transactions) based on the GL accounts entered in that table. This is the standard, multi-purpose GL interface record setup to accumulate financial transactions where customisation is not required. |
|
Dissect |
During transaction entry, users can choose from a list of GL interface records, giving them discretion as to how transactions are dissected to the General Ledger. |
|
Combination |
Ungreys the fields below (Warehouse Key, Item Key and Debtor Key) allowing you to select exactly how you want sales transactions dissected. This allows data to be transferred from the Distribution system based on the interrelations between the files that comprise your permanent records. For an example of how the Combination option works, refer to "Configuring MDS Integration". |
Where multiple warehouses exist, all financial transactions relating to sales invoicing for customers can be divided into separate GL accounts in the General Ledger.
Warehouses can be dissected and reported in one of the following ways:
|
Option |
Description |
Example |
GL Interface |
Master file update |
||||||||||||||||||||
|
None |
No dissection by warehouse |
-- |
-- |
-- |
||||||||||||||||||||
|
Ware(house) Item |
During sales invoicing, Micronet determines the relevant warehouse on an item-by-item basis. This occurs where items are being invoiced to customers from diverse warehouses, but on the same invoice. |
Both items are sold on the same invoice.
If sales need to be shown separately for each warehouse in the Profit & Loss, Micronet ensures that the sales appear in the General Ledger in the prescribed format:
|
GL interface records need to be setup and assigned to each inventory item |
Inventory master file - GL Interface field (refer to "File - Inventory - Item") |
||||||||||||||||||||
|
Warehouse |
Determines the warehouse on an invoice-by-invoice basis. This occurs where items are being invoiced to customers from one warehouse at a time. Items sold to customers from diverse warehouses invoice separately rather than together on the one invoice. |
Both items are sold separately on different invoices.
If sales need to be shown separately for each warehouse in the Profit & Loss, Micronet ensures that the sales appear in the General Ledger in the prescribed format:
|
GL interface records need to be setup and assigned to each warehouse record |
Warehouse master file - GL Interface field (refer to "File - Warehouse - Warehouse") |
Item Key
Financial transactions produced from sales invoicing can be reported in the General Ledger by an inventory classification.
Items can be dissected and reported in one of the following ways:
|
Option |
Description |
GL Interface |
Master file update |
|
None |
No dissection by item key |
-- |
-- |
|
Item |
As each item is added to a sales invoice, Micronet produces sales and customer transactions based on those items. These transactions update to the General Ledger based on integration specifications set for each item. This enables transactions to be transferred, grouped and reported in the General Ledger Profit & Loss by inventory item. This feature can also be used to group or classify item sales within the General Ledger in ways that may be absolutely unique to the business operation. |
GL interface records need to be setup and assigned to each inventory item |
Inventory master file - GL Interface field (refer to "File - Inventory - Item") |
|
Category |
As each item is added to a sales invoice, Micronet produces financial transactions for sales invoicing and transfers them to the General Ledger based on each item's product category. This enables transactions to be transferred, grouped and reported in the General Ledger Profit & Loss by product category groups. |
GL interface records need to be setup and assigned to each product category |
Product Category master file - GL Interface field (refer to "File - Product Category - Category") |
|
Barcode |
During sales invoicing to customers, transfers financial transactions to the General Ledger based on each item and its barcode. |
GL interface records need to be setup and assigned to each inventory item |
Inventory master file - GL Interface field (refer to "File - Inventory - Item") |
Debtor Key
Financial transactions produced from sales invoicing can be reported in the General Ledger by customer (debtor) classification.
Debtors can be dissected and reported in one of the following ways:
|
Option |
Description |
GL Interface |
Master file update |
|
None |
No dissection by debtor |
-- |
-- |
|
Debtor |
As a sales invoice is raised, Micronet produces sales and customer transactions based on integration specifications assigned to the individual customer. This enables transactions to be transferred, grouped and reported in the General Ledger Profit & Loss by customer type or classification. This option is very useful in accounting for GST where sales are made to overseas customers. These export sales are considered GST free for tax purposes. Dividing the debtor files into local and overseas ensures that local sales and export sales transfer and report separately in the General Ledger Profit & Loss report. |
GL interface records need to be setup and assigned to individual debtor (customer) records |
Debtor master file - GL Interface field (refer to "File - Debtor - Debtor") |
|
Sales Territory |
As each invoice is raised to a customer, Micronet produces financial transactions for sales invoicing and transfers them to the General Ledger based on the customer's assigned sales territory. This enables transactions to be transferred, grouped and reported in the General Ledger Profit & Loss by sales territory groups. |
GL interface records need to be setup and assigned to sales territory records |
Sales Territory master file - GL Interface field (refer to "Adding a New Sales Territory") |